MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Home / Check Tracker (.txt) next >

Wrap

FileMaker Pro Database | 1996-01-25 | 97KB | 679 lines

G\9| HBAM2016AUG95 Pro 3.0 (1rpu N@%Ia PXEpH\ ,X|%{ UFDgc /__Mw HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 o 3.0 AMNT CREDIT AMNT DEBIT AMOUNT BAL RUNNING CLEARED CREATED BY DATE CLEARED DATE MODIFIED DESCRIPTION PAID TO_OR FROM STATE STREET TRANS DATE TRANS NUMBER TTL AMNT CRED TTL AMNT DEB TTL AMOUNT ZIP CODE US English - Spelling Franz User Dictionary USENG.NDX Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12/8/95 Trans NumberB Date ModifiedB Paid To_or FromB Trans DateB DescriptionB Amnt CreditB ClearedB _m000011B 100)) _m000100B 1000) / 100) _m011000011000011000m011000m011000m011000m011000m011000m011000m011000m011000 Description This is a simple solution to record debits from and credits to a checking account. The Transaction List report calculates your running balance. How to use this solution Enter all your transactions as you write checks and withdraw or deposit money. Include the check number or transaction number in the Ref. No. field as a reference. How to customize this solution Add a new field called Category. Then, you can design a report that breaks down your financial transactions bB y category, so that you know where your money goes each month. See the documentation on Sub-summary reports for more information. sign the check printing layout to fit the design of your tractor feed checks. @@BA@ bRBBP0 B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" AD@D@ AD@D@ "%UR UD33D Amnt DebitB AmountB Ttl Amnt DebB Ttl Amnt CredB Ttl AmountB Bal RunningB StreetB CityB StateB ZIP CodeB Date ClearedB InfoB Created ByB Created ByB Created ByB StateB ZIP CodeB Date ClearedB InfoB Created ByB "B A Form View A List View Transaction List Information Report Menu A Form ViewB #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww A List ViewB Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Date Cleared ZIP Code Payee Address Description Deposit or Credit Withdrawal or Debit Paid To or From Ref. No. Enter data for Transactions Check Tracker Transaction ListB Your Own Buttonb Your Own Buttonc Recordd Delete Recorde Recordf Reportsg View As Listh View As Formi Closej Infok Balancel Creditm Debitn Paid To or Fromo Datep Ref No.q/Click to see more information for a Transaction InformationB Your Own Button Reports View As View As Close Paid To or From Ref. No. Balance Debit Credit Page ## Transaction List Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO,Information about the Check Tracker solutionP Info for this Solution Your Own ButtonB ReportsC View As ListD View As FormE CloseF InfoG Your Own ReportH Your Own ReportJ Transaction ListK>Click on any of these buttons to preview the respective reportL Select a reportM Your Own Report ReportH Your Own ReportJ Transaction ListK>Click on any of these buttons to preview the respective reportL Select a report Print CheckB Your Own ButtonB ReportsC View As ListD View As FormE CloseF 09/29/95 06/01/95 Beginning Balance Cleared 09/29/95 The Gas Company 06/02/95 Gas & electric bill 66.45 -66.45 Box 52001 San Francisco 94152-0002 09/29/95 The Phone Company 06/03/95 Telephone bill Twoill TwoOne TwoOne TwoOne TwoOne TwoOne Twone Twone Twone TwoOne TwoOne TwoOne TwoOne TwoOne Twone Twone Twone TwoTwo vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" 850.31 5399.69 5000C 4933.55D 4899.69E 4149.69F 5399.69 33.86 -33.86 10/01/95 Landlord 06/07/95 09/29/95 Employer 06/15/95 Deposit Paycheck Foure Fourq Fourq Fourhree Fouraycheck Three Fourne Three Fourne Three Fourwo Three Fouree FourThree Fourhree Fourree Fourree Fourhree Fouree Fouree Fouree Fourree Fourree FourThree Fourhree FourThree Fourree Fourree Fourhree Fourhree Fouree Fouree Fourq Foure Foure Fourq Foure Fourq Fourq FourFourFourFour Fourhree Fourk Three Fourq Fouro Three Fouro Three Fouro Three FourThree Fourhree Fourree Fourree Fourhree Fouree Fouree Fouree Fourree Fourree FourThree Fourhree FourThree Fourree Fourree Fourhree Fourhree Fouree Fouree Fourq Foure Foure Fourq Foure Sort by Date Sort by Transaction Number Sort by Paid To Transaction List Open Script Sort by Date Sort by Transaction Number Sort by Paid To Transaction List Open Script UUUUUU wwwwww Helvetica Geneva Times Times New Roman Arial MS Sans Serif )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Cleared VDEFA( Cleared List UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0% &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww